Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DEPTH

Syntax

Description of the illustration depth.gif

Purpose

`DEPTH` is an ancillary function used only with the `UNDER_PATH` and `EQUALS_PATH` conditions. It returns the number of levels in the path specified by the `UNDER_PATH` condition with the same correlation variable.

The `correlation_integer` can be any `NUMBER` integer. Use it to correlate this ancillary function with its primary condition if the statement contains multiple primary conditions. Values less than 1 are treated as 1.

See Also: EQUALS_PATH Condition, UNDER_PATH Condition, and the related function PATH

Examples

The `EQUALS_PATH` and `UNDER_PATH` conditions can take two ancillary functions, `DEPTH` and `PATH`. The following example shows the use of both ancillary functions. The example assumes the existence of the XMLSchema `warehouses.xsd` (created in "Using XML in SQL Statements").

    SELECT PATH(1), DEPTH(2)
       FROM RESOURCE_VIEW
       WHERE UNDER_PATH(res, '/sys/schemas/OE', 1)=1
         AND UNDER_PATH(res, '/sys/schemas/OE', 2)=1;

    PATH(1)                          DEPTH(2)
    -------------------------------- --------
    /www.oracle.com                         1

    /www.oracle.com/xwarehouses.xsd         2